b534672b278724d3719e8c4a6c46abea7245ab42,thunderbirdparser/src/org/sleuthkit/autopsy/thunderbirdparser/ThunderbirdMboxFileIngestModule.java,ThunderbirdMboxFileIngestModule,process,#AbstractFile#,83

Before Change


            Long mboxId = abstractFile.getId();
            String mboxPath = "";
            Long msfId = 0L;
            Case currentCase = Case.getCurrentCase(); // get the most updated case
            SleuthkitCase tskCase = currentCase.getSleuthkitCase();
            try {
                ResultSet rs = tskCase.runQuery("select parent_path from tsk_files where obj_id = '" + mboxId.toString() + "'");
                mboxPath = rs.getString("parent_path");
                Statement s = rs.getStatement();
                rs.close();
                if (s != null) {
                    s.close();
                }
                rs.close();

After Change


            //Long mboxId = fsContent.getId();
            String mboxPath = fsContent.getParentPath();
            Long msfId = 0L;
            currentCase = Case.getCurrentCase(); // get the most updated case
            SleuthkitCase tskCase = currentCase.getSleuthkitCase();
            try {
                ResultSet resultset = tskCase.runQuery("SELECT obj_id FROM tsk_files WHERE parent_path = '" + mboxPath + "' and name = '" + msfName + "'");